Steps to create source database 6

https://1drv.ms/u/s!AqynLAPPbtjviP1NTxP-X-j2JufJRA?e=GjmU4u


Follow the below steps to work with source data:

·      Click on the above link to download source data.

·      Before opening source file, make sure your Sql server instance is up and running.

·      Once you double click on downloaded file it will automatically open in SSMS (Sql Server Management Studio). It will take some time to load be patient. In the below GIF shows SSMS is up and running then opening source file which has Estimates (database name). And i am showing that i already have Estimates database in object explorer.


·      Before executing source file, make sure you created your database name Estimates. In my case I have already Estimates database so I am using different database name.

·      If you try to execute the source sql file (which has all the T-SQL statements in different batches of code to create database, tables, and insert values related to that table.) it will throw error since it is a pretty huge file.


·      To overcome the error use command prompt to execute the source file.



Follow the GIF steps you will successfully create source database.

·      Note: In the above image after username (this will be your username like c:\Users\Vnlax>) start from here copy exactly only by replacing your details. In command prompt give your Server name and your file path where you downloaded your file and type (\) then don’t forget to give file name with extension (or else it will throw an error) then press enter button. It will take couple of minutes be patient until you see C:\Users\username this will be your user login name. Now check all the tables been created and make sure you have all the rows in each table. The tblRepairOrders should have 96156, if its matching then your tables inserted values successfully in your source database.





Steps to create source database 6

https://1drv.ms/u/s!AqynLAPPbtjviP1NTxP-X-j2JufJRA?e=GjmU4u


Follow the below steps to work with source data:

·      Click on the above link to download source data.

·      Before opening source file, make sure your Sql server instance is up and running.

·      Once you double click on downloaded file it will automatically open in SSMS (Sql Server Management Studio). It will take some time to load be patient. In the below GIF shows SSMS is up and running then opening source file which has Estimates (database name). And i am showing that i already have Estimates database in object explorer.


·      Before executing source file, make sure you created your database name Estimates. In my case I have already Estimates database so I am using different database name.

·      If you try to execute the source sql file (which has all the T-SQL statements in different batches of code to create database, tables, and insert values related to that table.) it will throw error since it is a pretty huge file.


·      To overcome the error use command prompt to execute the source file.



Follow the GIF steps you will successfully create source database.

·      Note: In the above image after username (this will be your username like c:\Users\Vnlax>) start from here copy exactly only by replacing your details. In command prompt give your Server name and your file path where you downloaded your file and type (\) then don’t forget to give file name with extension (or else it will throw an error) then press enter button. It will take couple of minutes be patient until you see C:\Users\username this will be your user login name. Now check all the tables been created and make sure you have all the rows in each table. The tblRepairOrders should have 96156, if its matching then your tables inserted values successfully in your source database.